#pragma once
#include "CApplication.h"
#include "CRange.h"
#include "CRanges.h"
#include "CWorkbook.h"
#include "CWorkbooks.h"
#include "CWorksheet.h"
#include "CWorksheets.h"

class MyExcel
{
public:
	MyExcel(void);
	~MyExcel(void);
	void openExcel(CString path);
	void openSheet(CString name);
	CString GetCellValue(long row, long col);
	CString getCellValueByName(CString rowName, CString colName);
protected:
	CApplication	app_;
	CWorkbooks		books_;
	CWorkbook		book_;

	CWorksheets		sheets_;
	CWorksheet		sheet_;
	CRange			range_;
	LPDISPATCH		lpDisp_;
};

